﻿
package com.ostrich.manpower.controller;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import com.base.util.HtmlUtil;
import com.base.web.BaseAction;
import com.ostrich.manpower.bean.TostHrBaseinfo;
import com.ostrich.manpower.bean.TostHrSocialsecurity;
import com.ostrich.manpower.common.ImportUtil;
import com.ostrich.manpower.common.OstDateUtils;
import com.ostrich.manpower.service.impl.TostHrBaseinfoService;
import com.ostrich.manpower.service.impl.TostHrSocialsecurityService;

/**
 * ClassName: Controller <br/>
 * date: 2013-5-9 下午03:07:38 <br/>
 * 
 * @author wangyinan
 * @version
 */
@Controller
@RequestMapping("/tostHrSocialsecurity")
public class TostHrSocialsecurityController extends BaseAction
{
	private final static Logger log= Logger.getLogger(TostHrSocialsecurityController.class);

	// Servrice start
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrSocialsecurityService<TostHrSocialsecurity> tostHrSocialsecurityService; 
	@Autowired(required=false) //自动注入，不需要生成set方法了，required=false表示没有实现类，也不会报错。
	private TostHrBaseinfoService<TostHrBaseinfo> tosthrbaseinfoservice; 
	/**
	 * ilook 首页
	 * @param url
	 * @param classifyId
	 * @return
	 */
	@RequestMapping("/list") 
	public ModelAndView  list(TostHrSocialsecurity tostHrSocialsecurity,HttpServletRequest request) throws Exception{
		Map<String,Object>  context = getRootMap();
		List<TostHrSocialsecurity> dataList = tostHrSocialsecurityService.queryByList(tostHrSocialsecurity);
		//设置页面数据
		context.put("dataList", dataList);
		return forword("manpower/tabTostHrSocialsecurity",context); 
	}
	

	/**
	 * json 列表页面
	 * @param url
	 * @param classifyId
	 * @return
	 * @throws Exception 
	 */
	@RequestMapping("/dataList") 
	public void  dataList(TostHrSocialsecurity tostHrSocialsecurity,HttpServletResponse response) throws Exception{
		List<TostHrSocialsecurity> dataList = tostHrSocialsecurityService.queryByList(tostHrSocialsecurity);
		for(TostHrSocialsecurity ud: dataList){
			//这里可以做数据封装到对象中。
		}
		//设置页面数据
		Map<String,Object> jsonMap = new HashMap<String,Object>();
		jsonMap.put("total",tostHrSocialsecurity.getPager().getRowCount());
		jsonMap.put("rows", dataList);
		HtmlUtil.writerJson(response, jsonMap);
	}


	
	@RequestMapping("/save")
	public void save(TostHrSocialsecurity bean,Integer[] typeIds,HttpServletResponse response,HttpServletRequest request) throws Exception{
		Map<String,Object>  context = new HashMap<String,Object>();
		bean.setHsoMonth(OstDateUtils.getDateByMonth(bean.getHsoMonth()));
		System.out.println(bean+"=="+request.getParameter("hrId")+"=="+bean.getHsoMonth());
		if(bean.getId()==null||StringUtils.isBlank(bean.getId().toString())){
			tostHrSocialsecurityService.add(bean);
		}else{
			tostHrSocialsecurityService.update(bean);
		}
		sendSuccessMessage(response, "保存成功~");
	}
	
	@RequestMapping("/getId")
	public void getId(Integer id,HttpServletResponse response) throws Exception{
		Map<String,Object>  context = getRootMap();
		TostHrSocialsecurity bean  = tostHrSocialsecurityService.queryById(id);
		if(bean  == null){
			sendFailureMessage(response, "没有找到对应的记录!");
			return;
		}
		context.put(SUCCESS, true);
		context.put("data", bean);
		HtmlUtil.writerJson(response, context);
	}
	
	@RequestMapping("/delete")
	public void delete(Integer[] id,HttpServletResponse response) throws Exception{
		tostHrSocialsecurityService.delete(id);
		sendSuccessMessage(response, "删除成功");
	}
	
	@RequestMapping(value = "/upload", method = RequestMethod.POST)
	public ModelAndView upload(HttpServletRequest request,
			HttpServletResponse response, ModelMap model) throws IOException {
		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		// 得到上传的文件
		MultipartFile mFile = multipartRequest.getFile("excelPath");
		// 得到上传服务器的路径
		String path = request.getSession().getServletContext()
				.getRealPath("/WEB-INF/upload/");
		// 得到上传的文件的文件名
		String filename = mFile.getOriginalFilename();
		InputStream inputStream = mFile.getInputStream();
		byte[] b = new byte[1048576];
		int length = inputStream.read(b);
		path += "\\" + filename;
		// 文件流写到服务器端
		FileOutputStream outputStream = new FileOutputStream(path);
		outputStream.write(b, 0, length);
		inputStream.close();
		outputStream.close();
		request.setAttribute("path",path);
		request.setAttribute("month", request.getParameter("hsoMonth"));
		return new ModelAndView("forward:/tostHrSocialsecurity/upimport.do");
	}

	@RequestMapping(value = "/upimport")
	public ModelAndView upimport(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		Map<String, Object> context = getRootMap();
		String filepath = (String) request.getAttribute("path");
		String month = (String) request.getAttribute("month");
		try {
			InputStream fis = new FileInputStream(filepath);
			HSSFSheet sh = ImportUtil.getSheet(fis);
			
			String times = month.substring(0,4);
			String times1 = month.substring(5,7);
			  String ss = times + times1;
				
			String msg = tostHrSocialsecurityService.setsocialBySheet(sh,ss);
			request.setAttribute("success", "您已经导入成功请查看!");
			msg=(msg!=null && msg.trim().length()>0)?"您已经成功导入。但是还有："+msg:"您已经导入成功请查看。";
			request.setAttribute("msg",msg );
		} catch (Exception e) {
			e.printStackTrace();
			request.setAttribute("msg", "导入失败，请查看xls文件是否格式正确");
		}
		request.setAttribute("url", request.getContextPath()
				+ "/tostHrSocialsecurity/list.do");
		return forword("penmsg", context);
	}
}
	
